UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4bjP1RdsJWUVJctz4lkXOJ5MbrHBImEZjnMxrgHOqyw='
WHERE
key_id = '7af62c62e3293e0a700fcbd3030830d6304fe56df468d5de39849cfb26d51727'
AND (
token = '4bjP1RdsJWUVJctz4lkXOJ5MbrHBImEZjnMxrgHOqyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)