UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idiO31Ca9TrBoggGnBHg0rTb03sZ3HXARgHR3TLlCVY='
WHERE
key_id = 'c8b6293387edf68f99e8ae3fc278fb08f9c7580c66362b6392b0ef715d49d6b2'
AND (
token = 'idiO31Ca9TrBoggGnBHg0rTb03sZ3HXARgHR3TLlCVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)