UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GeQAi1kkuBg+y4uheKfN8+0PVoj2v/OOf07rhDgIDo4='
WHERE
key_id = 'fe99167f9c3d94d181b9191d1c570b9ac2b81fc7011caf50fc7c6b8a018fa87d'
AND (
token = 'GeQAi1kkuBg+y4uheKfN8+0PVoj2v/OOf07rhDgIDo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)