UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfLtgJRgkBOswejvf2h5AWn3plfO8vldk75FikttQSA='
WHERE
key_id = 'e9badfacc857be5a34f518f06c086f2608399fb7b8eded2c0d3887a346865a89'
AND (
token = 'XfLtgJRgkBOswejvf2h5AWn3plfO8vldk75FikttQSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)