UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Rx5hUHcsUoxBJ9AE41Of3kIsm6t86AZesKZv2AIjjQ='
WHERE
key_id = '0effeaf85ab614ca17252ee0abdf219a71ad27429ea78a28489bc58749ed7150'
AND (
token = '+Rx5hUHcsUoxBJ9AE41Of3kIsm6t86AZesKZv2AIjjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)