UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCosLQ1NCG50DUcykzq7WY+JlQY+njPpMiI9grJl/9Q='
WHERE
key_id = 'aa7e199b3a9b41a7f1c844c805809b39af5e4199a717f898ac792d06c983faf4'
AND (
token = 'HCosLQ1NCG50DUcykzq7WY+JlQY+njPpMiI9grJl/9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)