UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8U3CgsjWEVsAypx6Igpl/L4mdKMFZcsw9TUrvVkyIdU='
WHERE
key_id = '7e412617fb21ed8d4a058ef0a9281d6166306527d47c1951ac08dda38714fcbd'
AND (
token = '8U3CgsjWEVsAypx6Igpl/L4mdKMFZcsw9TUrvVkyIdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)