UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gVLXnyK0eMvztMH97hutod7V0sQpmwxdVInC01q0MeU='
WHERE
key_id = '3db584cd6a65cb08a1c05d73ed40d4c48cd07db316610435b5fa999555255286'
AND (
token = 'gVLXnyK0eMvztMH97hutod7V0sQpmwxdVInC01q0MeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)