UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SD8XH5oMXYaEMAUiTZqZOvraHm5i2XFBxk2jiRQ8va0='
WHERE
key_id = 'f38650f3e2b53d973e5e22616233a61abd60eafe55cb933985b4bd5db6630174'
AND (
token = 'SD8XH5oMXYaEMAUiTZqZOvraHm5i2XFBxk2jiRQ8va0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)