UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsbfWi3wyBZcDPDbhbbxi88W60jsLyXPGJJ7FjYIeKA='
WHERE
key_id = '680ca661fe0ee44bf815b9d8f1df57eee0d7a35303b9a836b39301e653697573'
AND (
token = 'ZsbfWi3wyBZcDPDbhbbxi88W60jsLyXPGJJ7FjYIeKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)