UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q1icKh74iNhGfC6jxH3shM4i65lWj13T8ZmKX6lE/rc='
WHERE
key_id = '13d27f9a42f3f492972a73f6564c96199983a21e168577671a34fb7932074dad'
AND (
token = 'q1icKh74iNhGfC6jxH3shM4i65lWj13T8ZmKX6lE/rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)