UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PzGNvgQOy8CW/slx4doLT2oFUonieu7+CBNZbbkmPHc='
WHERE
key_id = 'eff239d7c3ad4611494d8499d2bd6ba24053fc12e75f18c93783117bc7b3e8ed'
AND (
token = 'PzGNvgQOy8CW/slx4doLT2oFUonieu7+CBNZbbkmPHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)