UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RBWYRcvB8u7Y2H+rPaYQPvx0ohuKt3/z3syzlYXfJ4U='
WHERE
key_id = '7f40d7b0a7d5aa9f75b5c3dafe6436f6c920220f49a29f1ee35e4d4e05f2ae50'
AND (
token = 'RBWYRcvB8u7Y2H+rPaYQPvx0ohuKt3/z3syzlYXfJ4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)