UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bmS+20FgWgRCSWgBETdIvnUksLQ/UHexFRvzDFg3eoM='
WHERE
key_id = 'bed8e1e231346a2e30f242056438e11bd1cf31bd7f27372d63bcf9ce764c6ce5'
AND (
token = 'bmS+20FgWgRCSWgBETdIvnUksLQ/UHexFRvzDFg3eoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)