UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5PIzKMO067TsG3xzuJ+D3FLeJLyq7dfQ79d1rZctuZw='
WHERE
key_id = '92197def96e48555c2754fae11512b83ef087dda34105773b2339cc28b6ee895'
AND (
token = '5PIzKMO067TsG3xzuJ+D3FLeJLyq7dfQ79d1rZctuZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)