UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HLzlwp6QbksCX2q9S1lsqwZ2aPcYLyOY7ljWOvQkxOo='
WHERE
key_id = '8e27a849290d3b7bfd168fc288139f6d9143ed2509d0e6048303e4bfcf3fed6e'
AND (
token = 'HLzlwp6QbksCX2q9S1lsqwZ2aPcYLyOY7ljWOvQkxOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)