UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uR7yWH5PjgjBmx/QNyvDYPfh8dMmO7WpC2as6K6miWA='
WHERE
key_id = '9aa252f837ed559326bb6e1870ad508c3837d448fee5e69e5d6dce43b7597fb1'
AND (
token = 'uR7yWH5PjgjBmx/QNyvDYPfh8dMmO7WpC2as6K6miWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)