UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hGvOA0uQFlXX87d42GkbwiawHTxW1isIkRdu6tM9CDI='
WHERE
key_id = '4bc93baa9d3123883184b8a2cf2cdeb43b3e2791e011d3f83965ade170c7ff0c'
AND (
token = 'hGvOA0uQFlXX87d42GkbwiawHTxW1isIkRdu6tM9CDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)