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