UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBDYDpZOi8+wWO+aRs6tP9eomIkVF5hoecHZYfr49Lk='
WHERE
key_id = 'c0039881721b143bc69f443edc25f40194ba50d70b0fe1d732bcd0f37068ae92'
AND (
token = 'TBDYDpZOi8+wWO+aRs6tP9eomIkVF5hoecHZYfr49Lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)