UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cL4g1EV1CWs1+Mzq6ZYILkmKVD9GqFPEt3MOwa8Q75E='
WHERE
key_id = 'c0f21428226de88dd0367d2206807bc7d726ed12add38e9735d9a448809737ce'
AND (
token = 'cL4g1EV1CWs1+Mzq6ZYILkmKVD9GqFPEt3MOwa8Q75E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)