UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'feZ7CsYjxfXpT9FEvLuNObzZEN6OftjpscovnUcHEKs='
WHERE
key_id = 'b8e23119f53493c07ba99ec893da1e48a7890cd7cbafe44d68528482d3cffbb0'
AND (
token = 'feZ7CsYjxfXpT9FEvLuNObzZEN6OftjpscovnUcHEKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)