UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUp607zL2U1oxrwnWTULOrBJb/xOBKD4dIUd9UVovKU='
WHERE
key_id = 'bcf783756bc5598d6bad1bacf87708f4e6ee3cfaae524d58c65eb4efe106c6b2'
AND (
token = 'nUp607zL2U1oxrwnWTULOrBJb/xOBKD4dIUd9UVovKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)