UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xDpxrsydOjWCixdMIC2veutAftd/rrZwRoZM1PoT7sI='
WHERE
key_id = '328a3245504ad89c1e18cde3ce304d23f708e4d1fd6c05b7d11d30e5a81f11f0'
AND (
token = 'xDpxrsydOjWCixdMIC2veutAftd/rrZwRoZM1PoT7sI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)