UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8kBWZdltihBcvOsZDqsYVKV75wI/L+qe8MJGJi8EWsI='
WHERE
key_id = '532c527bd46c40a4d4355752adaa9179c05bdcff0650c5afa6cb33eecf2e7260'
AND (
token = '8kBWZdltihBcvOsZDqsYVKV75wI/L+qe8MJGJi8EWsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)