UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YkGe8YW6u4wU6oD/MRRB22wKszbLc7yshGvsPhbDQI='
WHERE
key_id = 'af26d14b361da7926df6e9c37cef99f09f28edb6ea4a9191836c9efc0099b686'
AND (
token = '1YkGe8YW6u4wU6oD/MRRB22wKszbLc7yshGvsPhbDQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)