UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdi1pdNfUJAk+JobeVyIOqZj1mJ4Ig7iH7XGQTFoNX0='
WHERE
key_id = '8f975e97c0c3274d148ecf35b8ce5749cee9b6c88d47b10d047efca35a1f39fc'
AND (
token = 'zdi1pdNfUJAk+JobeVyIOqZj1mJ4Ig7iH7XGQTFoNX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)