UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1lRMIDji2VPF9uzupdSwuy8ylgoGQr99B8tP+rORNU='
WHERE
key_id = 'da07f13ca1e2e615ba929f0a7a88207bb1e4ae384cbb62dc295d3738a736723c'
AND (
token = 'X1lRMIDji2VPF9uzupdSwuy8ylgoGQr99B8tP+rORNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)