UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Erg/jL4nZg3obvVAAClHlH3frNRQpG1XPQsCGTGGhP8='
WHERE
key_id = '8f8e0914342f853e9c9ef413c6ed782bdabcf82bd90ad06e6f00a4594d512ae6'
AND (
token = 'Erg/jL4nZg3obvVAAClHlH3frNRQpG1XPQsCGTGGhP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)