UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/BRDZSY8SX9QWusWCzTq6cFG9N5w/dhAe1G0p5W1UbM='
WHERE
key_id = 'b0fd4f2dcba5555e23016d00904ae9bdbd53402004929a724f508cda96c681da'
AND (
token = '/BRDZSY8SX9QWusWCzTq6cFG9N5w/dhAe1G0p5W1UbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)