UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JGFhXBJjZ7IkORNAXVd+2XoZq4na+NvVvfFWC96S/Z8='
WHERE
key_id = 'a6b3f7177b505a2aadc78c10dd5fedc630c567d43422bf1ffbe99d34eb628f2a'
AND (
token = 'JGFhXBJjZ7IkORNAXVd+2XoZq4na+NvVvfFWC96S/Z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)