UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hsL1wt55Tp4kk7wKa7b9MWDWxBQ3bayT7vV71CD/DQ='
WHERE
key_id = 'c12c8ec20534685b7c718cc72bcc98a653905b2e084e0a69209ea8153a097fd7'
AND (
token = '7hsL1wt55Tp4kk7wKa7b9MWDWxBQ3bayT7vV71CD/DQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)