UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPdmHP7GwnHGYTNsyG9bgeZLI6Eq3UdWaZn8aA2oB14='
WHERE
key_id = '6b4d872643e06966968a6fc60dc4fc22a402021b808611fb0a897125f743a502'
AND (
token = 'BPdmHP7GwnHGYTNsyG9bgeZLI6Eq3UdWaZn8aA2oB14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)