UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oIBy1lr/R+s/LDcGJzTBpFy33uiX7R43/TgRcYMCwwI='
WHERE
key_id = '16e574c817991552d6238be8b7c90a48b1b6b070b75ceaa9a1c5a35e548e204a'
AND (
token = 'oIBy1lr/R+s/LDcGJzTBpFy33uiX7R43/TgRcYMCwwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)