UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdscXIAqORGKMUDZj439xjJtLdPtySwWWDuN38dOZEI='
WHERE
key_id = '0065c780088cf4feebdf1a49f60d9b8a2df592e317e70fe0a8e4b85a992e1723'
AND (
token = 'XdscXIAqORGKMUDZj439xjJtLdPtySwWWDuN38dOZEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)